Referential integrity means

  1. Home
  2. Back

Computer - Online Exam Test Papers | Computer - MCQs[multiple choice questions and answers ] | Computer - Mock Test Papers | Computer - Practice Papers | Computer - Sample Test Papers |

Question:
Referential integrity means

1.Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table

2. Do not enter a value in the primary key field of chield table if that value does not exist in the primary key of the parent table

3.Do not enter a value in the foreign key field of a parent table if that value does not exist in the primary key of the child table

4.All of above

Posted Date:-2021-02-19 15:27:11

More MCQS Questions and answers

  1. After entering all fields required for a table if you realize that the third field is not needed how will you remove?
  2. Both conditions display on the same row in the design grid when ___operator is in use
  3. Cascade delete option
  4. If you need to edit a relationship
  5. It is a database object to view change and analyze data in different ways
  6. It is most common type of query. It retrieves records from one or more tables and then displays the
  7. The___ operator will cause a record to be selected only if two or more conditions are satisfied
  8. What do you mean by one to many relationship between student and class table?
  9. When a picture or other graphic image is placed in the report header section it will appear____
  10. While creating relationship when you drag a field of a field to drop into another table the mouse pointer changes into
  11. You can automatically include all of the field in a table in a query by___ a strike that appear list box in query design view
  12. A search value can be an exact value or it can be
  13. A __ name must be unique within a database
  14. Cascade update option
  15. If you write criteria values vertically (one in a row) it will mean
  16. Which of the following is not a field type in access
  17. Queries in access can be used as
  18. Referential integrity means
  19. The expression builder is an access tool that controls an expression___ for entering an expression
  20. The key uniquely identifies each record in a table.
  21. The__ button on the tool box display data from a related table
  22. To achieve and effect when you are entering criteria in a query design window
  23. To create queries in access
  24. Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find relationship command
  25. Unlike text data type this can store up to maximum of 65 535 characters.
  26. We can remove a relationship defined between two tables by
  27. What is a form in MS Access
  28. When entering field name how many characters you can type in maximum?
  29. Which field type can store photos?
  30. Which of the following statement is true
  31. You can set a controls border type to make the border invisible.
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!